Release 10.1A: OpenEdge Data Management:
Database Administration

Resolve Limbo Transactions

Lets you resolve a limbo transaction by either committing or aborting the transaction. When you choose this option, PROMON displays the menu shown in Figure 19–49.

1 Abort a Limbo Transaction      2 Commit a Limbo Transaction      Q Quit      Enter choice>

Figure 19–49: PROMON Resolve Limbo Transactions menu

Choose one of the following options:

Abort a Limbo Transaction — When you choose Abort a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to abort. PROMON displays the user’s number in the User column of the Transaction Control option screen. Type the user number, then press RETURN.
Commit a Limbo Transaction — When you choose Commit a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to commit. (PROMON displays the user number in the Usr column of the Transaction Control option screen.) Type the user number, then press RETURN. PROMON displays a message similar to the following:

User 1: commit transaction and disconnect.

Note: To commit transactions on a database that is shut down, you must use the 2PHASE RECOVER qualifier of PROUTIL.